Aggregate-join Query processing in parallel database systems - High Performance Computing in the Asia-Pacific Region, 2000. Proceedings. The Fourth International
نویسنده
چکیده
Queries containing aggregate functions o f e n combine multiple tables through join operations. We call these queries "Aggregate-Join" queries. In parallel processing of such queries, it must be decided which attribute to be used as a partitioning attribute, particularly join attribute or group-by attribute. Based on the partitioning attribute, we discuss three parallel aggregate-join query processing methods, namely Join Partition Method (JPM), Aggregate Partition Method (APM), and Hybrid Partition Method (HPM). The JPM and APM models use the join attribute, and the group-by attribute, respectively, as the partitioning attribute. The HPM model combines the other two methods using a logically hybrid architecture.
منابع مشابه
Parallel Processing of Multi-Join Expansion_aggregate Data Cube Query in High Performance Database Systems
Data cube queries containing aggregate functions often combine multiple tables through join operations. We can extend this to “Multi-Join Expansion_Aggregate” data cube queries by using more than one aggregate functions in “SELECT” statement in conjunction with relational operators. In parallel processing for such queries, it must be decided which attribute to use as a partitioning attribute, i...
متن کاملPerformance Evaluation of Parallel GroupBy-Before-Join Query Processing in High Performance Database Systems
Strategic decision making process uses a lot of GroupBy clauses and join operations queries. As the source of information in this type of application to these queries is commonly very huge, then parallelization of GroupBy-Join queries is unavoidable in order to speed up query processing time. In this paper, we investigate three parallelization techniques for GroupBy-Join queries, particularly t...
متن کاملOn the Performance of Parallel Join Processing in Shared Nothing Database Systems
Parallel database systems aim at providing high throughput for OLTP transactions as well as short response times for complex and data-intensive queries. Shared nothing systems represent the major architecture for parallel database processing. While the performance of such systems has been extensively analyzed in the past, the corresponding studies have made a number of best-case assumptions. In...
متن کاملEmpowerment of Medical Toxicology in South Korea
In a recent issue of the Asia Pacific Journal of Medical Toxicology (APJMT), the importance of empowering medical toxicology in the Asia Pacific Region has been discussed. In the editorial by Dr. Afshari, it has been stated that national societies of medical toxicology are important infrastructure for the development of medical toxicology, and the Asia Pacific Association of Medical Toxicology ...
متن کاملA Comparative Appraisal of Roadway Accident for Asia-Pacific Countries
This paper describes an attempt to shed some light on road safety in Asia Pacific region by characterizing and assessing its road accidents. The relevant national road accident data were extracted from centralized data sources of international agencies. Due to data incompleteness and missing values, 21 Asia Pacific countries, presenting more than half of the world’s population, were selected fo...
متن کامل